UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xm2siG8amXHJYU7iw/BJAwfXOQJP1mb2ch2Aw9K6aHc='
WHERE
key_id = 'fd07a47fef6c7daed4fa13db7d2a2becf1df797bba22e6710c05339d8458e8be'
AND (
token = 'xm2siG8amXHJYU7iw/BJAwfXOQJP1mb2ch2Aw9K6aHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)