UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKxJ7ht5l3HjqaBnOk4r022SBxlXuFU5iJeBJ8vElZg='
WHERE
key_id = '2f074808386e4e74830f57e681a50390b7df87f498cd7d83979f7b84626f6568'
AND (
token = 'lKxJ7ht5l3HjqaBnOk4r022SBxlXuFU5iJeBJ8vElZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)