UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wUiE7HbrnniQ5RFBz5REGjzRQku56YfWXeBf3mKRYiQ='
WHERE
key_id = '50710b8168b10a006ec3f10cbd0cb9ddd336e9cf0c300adc3992ab1b098be790'
AND (
token = 'wUiE7HbrnniQ5RFBz5REGjzRQku56YfWXeBf3mKRYiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)