UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bOnNkxB4CtIcUBDLQdTQ8JfFJG6JhKwj4I0qGo09Gcw='
WHERE
key_id = '5b7c88cf74cf7f8e73d7cdc95d9f9250c80002d972e8217a406a083f87515692'
AND (
token = 'bOnNkxB4CtIcUBDLQdTQ8JfFJG6JhKwj4I0qGo09Gcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)