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