UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '227mhauIy4CV4ljIM87JCYdZRJc3wkHkGwmRhfEZvt0='
WHERE
key_id = '60b3da11e618fb6e0e5e7c0852c29863be7d433944b7065f6a2e491bc8ef5826'
AND (
token = '227mhauIy4CV4ljIM87JCYdZRJc3wkHkGwmRhfEZvt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)