UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgH2RCckXgDIAtJNZiRmdSfBaJNDYUxvlmoJZXDOu3w='
WHERE
key_id = '4995d28513f1964ba946e1a1c66a1ba506860f2b75b7bde107542d0bb14ef118'
AND (
token = 'KgH2RCckXgDIAtJNZiRmdSfBaJNDYUxvlmoJZXDOu3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)