UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H+i9EKIcW2Ro5no+LkYsWhC24Ux9Om1clrq4pH282Ic='
WHERE
key_id = '4963f0e300c054282abfd8f65ae5617d2b99b873e5e6360b218f99314b02ce48'
AND (
token = 'H+i9EKIcW2Ro5no+LkYsWhC24Ux9Om1clrq4pH282Ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)