UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gxKBfToilvwKZH+D+bwoJayJxwPbUGLMp+P19M3MAk8='
WHERE
key_id = '5799376b81f50938dbc37709d75de66f1d1fb82cd08482ff1e67aaedf65b3044'
AND (
token = 'gxKBfToilvwKZH+D+bwoJayJxwPbUGLMp+P19M3MAk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)