UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CjLT0AWCSxUuChKG583mgKbZBe10NuUBgYz0Y1W7Gxk='
WHERE
key_id = 'a8eb6ab5f565e3042c6fb4a2c0a5828bdbfc0cafdd9e5fce851bd45f0e2362a5'
AND (
token = 'CjLT0AWCSxUuChKG583mgKbZBe10NuUBgYz0Y1W7Gxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)