UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6PJ+UBVwUCo7ODANcawIYa4v7CshIKHsEPOI+ODKanA='
WHERE
key_id = '7fdde854a5b45662e25c909b8bab5fee8ca8845215bfe5f89fce059f3400c2a3'
AND (
token = '6PJ+UBVwUCo7ODANcawIYa4v7CshIKHsEPOI+ODKanA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)