UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWxRDDJdWy31VgZs+DIsPfWqUj2OTK+Jq+9G+KbIIyI='
WHERE
key_id = 'b4095c3c020d639fd05fef959b6b44b0d91545b3683577e68a8e435b1dc11ae1'
AND (
token = 'ZWxRDDJdWy31VgZs+DIsPfWqUj2OTK+Jq+9G+KbIIyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)