UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4UJDNvGs45A9QFdpKQN7+xAAnHLgkUE2VMLFPC5FGwE='
WHERE
key_id = '00c50c69be0585c50ed0b462a3bfb00b9a10568c369313b566bb2adaa391f415'
AND (
token = '4UJDNvGs45A9QFdpKQN7+xAAnHLgkUE2VMLFPC5FGwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)