UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HXXbIGx729AZFJZiKRF25hoKQZtsNhBjgw38Z8oXTzI='
WHERE
key_id = 'f2521ae694cd6d86f843330b9c83a0c27a82ddf19188855e0ff7fa29c65a99d4'
AND (
token = 'HXXbIGx729AZFJZiKRF25hoKQZtsNhBjgw38Z8oXTzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)