UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0to4zJ+il0k8UokXs7yNH5Z95VHQAo+SaFq1Qt8e+tA='
WHERE
key_id = '46cbe991b2ad549135d024ed566093ed4d9b89a387d7a91e9fced56fc2c9837b'
AND (
token = '0to4zJ+il0k8UokXs7yNH5Z95VHQAo+SaFq1Qt8e+tA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)