UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'relH94SGTMctQ/A2tegGWkGyUFssqweR5luzbWu6szU='
WHERE
key_id = '4061333a25d00f267f1a7246aad0e2508763e45e4ad7afca33897dc4a2fdbc2b'
AND (
token = 'relH94SGTMctQ/A2tegGWkGyUFssqweR5luzbWu6szU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)