UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X3JTcilL3aubE9ekpA9teezvK/lkOgoGUXZ6Dm7SQTQ='
WHERE
key_id = 'b47a1ac621a2b6fabce87df7e4be836cc4082f65cc3ffa7eb56f9ad33302e970'
AND (
token = 'X3JTcilL3aubE9ekpA9teezvK/lkOgoGUXZ6Dm7SQTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)