UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '865cvuj1MVwNs2+c249L32S+kGcCrLj+zHxscRUF1Dg='
WHERE
key_id = '6d737819834af70f2f8f4b50ed261b9205cdcd76206a720f89c0edb3ce2dac58'
AND (
token = '865cvuj1MVwNs2+c249L32S+kGcCrLj+zHxscRUF1Dg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)