UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8wBNAdvSwDjP2iLUvS6e9YqORARmT8qAkh28RFk+cM='
WHERE
key_id = 'bb367f38d6721bdadb48a9d2972521c12da6080c70fa48e548d5b007e6b3b12f'
AND (
token = 'n8wBNAdvSwDjP2iLUvS6e9YqORARmT8qAkh28RFk+cM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)