UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JNvvKROMxdM6wzrAiy1dUbyN0Ork9THoQOUF1SjuZ/8='
WHERE
key_id = '596dd44efbe460c5ecb56f623303f21fe7682a2df61cae527b99325d15c22e27'
AND (
token = 'JNvvKROMxdM6wzrAiy1dUbyN0Ork9THoQOUF1SjuZ/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)