UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tIUXeZcvjV9466D3lfCsV7mq96cEKKghptyeVci/87U='
WHERE
key_id = '20607333e8f7dfe05c72de5956eca5f439708e6966cfe4d7a649ad8638ef7930'
AND (
token = 'tIUXeZcvjV9466D3lfCsV7mq96cEKKghptyeVci/87U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)