UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T1qOHY25OwF/lBzF/bV9ElkJXW1G2rbeTvUUY5VC8rU='
WHERE
key_id = 'e8f2c05f3a5ececb63c34a4cb65ce069fe8d521ef881ca96dcb723633a93fbfc'
AND (
token = 'T1qOHY25OwF/lBzF/bV9ElkJXW1G2rbeTvUUY5VC8rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)