UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xIW+B3j3wI9OP/QdXr9yVYAUeqAyOOI82nqguRnsm3k='
WHERE
key_id = 'e630dd6b6b6b3884b92560d81058951ad356d196a3482378ac80c0d49c1559df'
AND (
token = 'xIW+B3j3wI9OP/QdXr9yVYAUeqAyOOI82nqguRnsm3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)