UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bolcAKUKru4xv2aCZZk04D60Kcnc7Tjsj7uDqVbc9xU='
WHERE
key_id = 'a9bd29033b60fe73194edf4c55e42b47d580143a379a64a9441b0d933884b18c'
AND (
token = 'bolcAKUKru4xv2aCZZk04D60Kcnc7Tjsj7uDqVbc9xU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)