UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hAN1OvoiAoCLkQb+kiW3s7kiDGix3FopWPnYlVF0vQA='
WHERE
key_id = '3dc5cadadd20a3690882c9abad1038a1a68bdad17c8291e8e5de52a6d42896a5'
AND (
token = 'hAN1OvoiAoCLkQb+kiW3s7kiDGix3FopWPnYlVF0vQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)