UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9MnENgwTn2svVfCH1Xn3lkQkdCte5F+0Apkj+XkvDcc='
WHERE
key_id = '50219335341eb1d6a1471fcbd70d867c6907200a45c684c89bb42df7e4cf8160'
AND (
token = '9MnENgwTn2svVfCH1Xn3lkQkdCte5F+0Apkj+XkvDcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)