UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jg2vA2+c/I/TYtgHJVY5JEDnLRpmVpnhB0/fYZ1Xy2Q='
WHERE
key_id = '8ce5a69d04addb8c2132017dcc66d8cc28f1f3c4e6bf36c8f80bd1c6e00dfdb5'
AND (
token = 'Jg2vA2+c/I/TYtgHJVY5JEDnLRpmVpnhB0/fYZ1Xy2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)