UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CQgL7RPGd4FTykn4+7ygyehtp49p6W6T8WZGbJA+S0='
WHERE
key_id = '7f871e385cf568ccea0f4da62eba93dc978db9470966557cf8d2538d71ae067e'
AND (
token = '8CQgL7RPGd4FTykn4+7ygyehtp49p6W6T8WZGbJA+S0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)