UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7JKVl/H8u6ZmPaFNPosCdCBspHNzU3mKf/uZ6RfgZ5c='
WHERE
key_id = '49067721945d8a69b1b696d5e13e48612b16c8f527e39bc3999ef23ee131ae72'
AND (
token = '7JKVl/H8u6ZmPaFNPosCdCBspHNzU3mKf/uZ6RfgZ5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)