UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4PENEXU9hmjjInrS1slU9nHc2FicOA17JYGnDau8iuM='
WHERE
key_id = 'a4434707bdbd2d0ddfb04cb897cd6df0983581efdd74e419bccb38c95e24fdf2'
AND (
token = '4PENEXU9hmjjInrS1slU9nHc2FicOA17JYGnDau8iuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)