UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aDnoMYcY5W2YLqG/45FxeMDZxc5FxRinzAU1G6hEixQ='
WHERE
key_id = 'a1fd8d9eb21be6f57edfed5ef3456a04190e72c946297581336672f5f371f934'
AND (
token = 'aDnoMYcY5W2YLqG/45FxeMDZxc5FxRinzAU1G6hEixQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)