UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2UuaCmZCbh3YdJVJWK/bndkVk7QhpDVTYXfQVyzP+Kk='
WHERE
key_id = '02e808402b2b0dca958cbc3625f23e24c800ae8090555371ac399e5749842de3'
AND (
token = '2UuaCmZCbh3YdJVJWK/bndkVk7QhpDVTYXfQVyzP+Kk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)