UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0c4d3XWz4jzuBIM11iRGaaEt9CUZWrCDZ4vXxqk2KU='
WHERE
key_id = '0bdc380dabd1b72314d5d3a0f10261ce7126c061e9a2cb6bb402e19c86a9073b'
AND (
token = 'p0c4d3XWz4jzuBIM11iRGaaEt9CUZWrCDZ4vXxqk2KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)