UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jXsAi1fjSf23r1DVLqsNgIypXRHuQbT+7ghZxqhfQYI='
WHERE
key_id = 'a9d1176a50c9c78841957c96a0fc425c15c617cdf2bb96dd8bf51a86cdc0dbfc'
AND (
token = 'jXsAi1fjSf23r1DVLqsNgIypXRHuQbT+7ghZxqhfQYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)