UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1dKIIWkRantaNFAFWxtaZjPGrcI9DFex+VFZzAed9Ww='
WHERE
key_id = 'a6f11fcf10958b1942a59681d34d02c26980ce98f624230650c709ff5c9185d4'
AND (
token = '1dKIIWkRantaNFAFWxtaZjPGrcI9DFex+VFZzAed9Ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)