UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R4eWZj4YQokOgrhL6B4BBO9i0RhZ/JLei/yyGtdbIDE='
WHERE
key_id = '99ff4ecdd10e108b0369a62b8d2d36b8a40d159644a749842e8c6954998cb10e'
AND (
token = 'R4eWZj4YQokOgrhL6B4BBO9i0RhZ/JLei/yyGtdbIDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)