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